package com.aimao.blog.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author PuaChen
 * @Create 2018-08-02 16:26
 */
@Mapper
public interface ImageMapper {

    @Select("select mainImg from admin")
    List<String> selectImgAllByAdmin();

    @Select("select mainImg from article where mainImg != ''")
    List<String> selectImgAllByArticle();

    @Select("select mainImg from `subject` where mainImg != ''")
    List<String> selectImgAllBySubject();

    @Select("select content from `article` where content != ''")
    List<String> selectArticleContent();

    @Select("select img from `banner` where img != ''")
    List<String> selectBannerImages();
}
